<?php
#include ('../../config/testing/database.php');



$hocky=$_GET('hk');
$namhoc=$_GET('nh');
$id=$_GET('id');
$sql="select* from de_tai_luan_van a,chi_tiet_can_bo_huong_dan b,hoc_ky_nien_khoa c where 
    de_tai_luan_van.id=chi_tiet_can_bo_huong_dan.id_de_tai
    and de_tai_luan_van.id_hoc_ki_nien_khoa=hoc_ky_nien_khoa.id
    and chi_tiet_can_bo_huong_dan.id_can_bo=$id
    and hoc_ky_nien_khoa.nien_khoa=$nienkhoa 
    and hoc_ky_nien_khoa.hoc_ky =$hocky
    and de_tai_luan_van.trang_thai=1";
$result=@mysql_query($sql);
$stt=0;
while ($row=@mysql_fetch_array($result))
    {
    echo '<tr>';
    echo '<td >$stt</td>';
    echo '<td >$row["ma_so_de_tai"]</td>';
    echo '<td >$row["ten_de_tai"]</td>';
    $String='?NienKhoa=$namhoc&&HocKy=$hocky&&chon=sua&&iddt=$row["ma_so_de_tai"]';
    echo '</tr>';
    $stt++;
        }

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
?>
